Unique Override Registry entry

Specify that a user / group can save a record even if a Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record and that column or combination of columns is not unique.

Usage

This Registry entry can be assigned to users and groups:

Key	User	User	Group	Group	Group	Group
Key 1	`User`	`User`	`Group`	`Group`	`Group`	`Group`
Key 2	user	user	group	group	`Default`	`Default`
Key 3	`Table`	`Table`	`Table`	`Table`	`Table`	`Table`
Key 4	table	`Default`	table	`Default`	table	`Default`
Key 5	`Unique Override`
Key 6	column;column;...
Value	boolean

In pipe-delimited format:

where:

column;column;...

must match the column list specified in the Unique Registry entry to be overridden.

boolean

is true or false.

If true, the user / group will be informed that the column or combination of columns is not unique, but will be asked if they want to continue with saving the record. An affirmative response will continue with saving the record. A negative response will abort the save and move the cursor to the control associated with the first column listed in the Unique Registry entry.

If false, the record will not be saved and the warning message specified in the Unique Registry entry will display; the cursor will move to the control associated with the first column listed in the Unique Registry entry.

Note: In the absence of this entry, a setting of false is assumed.

Example

This entry allows users in the Admin group to override the uniqueness constraint specified in the previous Unique Registry entry:

Key	Setting
Key 1	`Group`
Key 2	`Admin`
Key 3	`Table`
Key 4	`eparties`
Key 5	`Unique Override`
Key 6	`BioBirthDate;NamFirst;NamLast`
Value	`true`